﻿CREATE TABLE [dbo].[ASMS_Customer]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Number] nvarchar(32),
	[Name] nvarchar(32) NOT NULL, 
	[Telephone] nvarchar(32) NOT NULL,
	[EMail] nvarchar(128),
	[IdNumber] nvarchar(32) NULL,
	[Country] nvarchar(64),
	[Province] nvarchar(64),
	[City] nvarchar(64),
	[District] nvarchar(64),
	[Address] nvarchar(256),
	[Type] nvarchar(32),
	[QQ] nvarchar(32),
	[Wechat] nvarchar(64),
	[VIPNumber] nvarchar(64),
	[VIPLevelCode] nvarchar(16),
	[Gender] int,
	[Birthday] datetime,
	[IsCredit] bit NOT NULL,
	[SalesManagerId] uniqueidentifier,
	[BusinessId] uniqueidentifier,
	[StationId] uniqueidentifier,
	[Status] int NOT NULL,
	[AppSyncedTime] datetime,
	[OfflineId] uniqueidentifier,
	[Creator] nvarchar(64) NOT NULL,
	[CreatedTime] datetime NOT NULL
)